# -*-coding: Utf-8 -*-
# @File : ExcelData.py .py
# author:
# Time：2024/3/15
from  openpyxl  import  load_workbook
class ExcelData:
    @staticmethod
    def read_test_data_from_excel():
        wb = load_workbook(
            filename=r"/ZhengzhouAPPAutomationProject/Sina_Appium_Test/新建 XLSX 工作表 (2).xlsx")
        st = wb["搜索数据"]
        data = [[st.cell(row=i, column=j).value for j in range(1, 2)] for i in range(2, st.max_row + 1)]
        return data